Mysql Invalid default date value if zeros

Posted on September 4, 2021, 6:02 pm, by admin, under mysql.

Step 1

mysql> show variables like 'sql_mode' ;
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 
 
Step 2 
Add to mysqld.cnf
<pre lang="bash">
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Step 3
Restart mysql

Comment (RSS)  |  Trackback

Leave a Reply

«
»